using System;
using System.Collections.Generic;
using System.Text;
using Shc.Sql;
using Shc.Json;
namespace CLZ.Data
{
	public static class TableViewMembers
	{
		public const string Table = "View_Members";
		public const string MembersID = "MembersID";
		public const string RegionID = "RegionID";
		public const string AreaID = "AreaID";
		public const string ApproveStatusID = "ApproveStatusID";
		public const string LoginName = "LoginName";
		public const string Password = "Password";
		public const string MemberName = "MemberName";
		public const string MemberNo = "MemberNo";
		public const string CompanyName = "CompanyName";
		public const string Contact = "Contact";
		public const string IDNO = "IDNO";
		public const string TelePhone = "TelePhone";
		public const string Email = "Email";
		public const string Mobile = "Mobile";
		public const string Fax = "Fax";
		public const string Address = "Address";
		public const string ZipCode = "ZipCode";
		public const string WebSite = "WebSite";
		public const string Description = "Description";
		public const string LastLogin = "LastLogin";
		public const string Activity = "Activity";
		public const string MemberStatus = "MemberStatus";
		public const string Creater = "Creater";
		public const string CreatedBy = "CreatedBy";
		public const string Created = "Created";
		public const string Modified = "Modified";
		public const string ModifiedBy = "ModifiedBy";
		public const string ModifiedByID = "ModifiedByID";
		public const string IsTransfer = "IsTransfer";
		public const string AccountNo = "AccountNo";
		public const string AccountName = "AccountName";
		public const string ShoppingTypeID = "ShoppingTypeID";
		public const string CityID = "CityID";
		public const string ProvinceID = "ProvinceID";
		public const string CityName = "CityName";
		public const string ProvinceName = "ProvinceName";
		public const string RegionName = "RegionName";
		public const string AreaName = "AreaName";
		public const string AreAreaID = "Are_AreaID";
		public const string ParentName = "ParentName";
	}
	
	[Serializable]
	public class BaseViewMembers
		: IDbSessionEntity, IJsonClass
	{
		int m_MembersID;
		/// <summary>
        /// 
        /// </summary>
        public int MembersID
        {
            get { return m_MembersID; }
            set { m_MembersID = value; }
        }
		
		int? m_RegionID;
		/// <summary>
        /// 
        /// </summary>
        public int? RegionID
        {
            get { return m_RegionID; }
            set { m_RegionID = value; }
        }
		
		int? m_AreaID;
		/// <summary>
        /// 
        /// </summary>
        public int? AreaID
        {
            get { return m_AreaID; }
            set { m_AreaID = value; }
        }
		
		int m_ApproveStatusID;
		/// <summary>
        /// 
        /// </summary>
        public int ApproveStatusID
        {
            get { return m_ApproveStatusID; }
            set { m_ApproveStatusID = value; }
        }
		
		string m_LoginName;
		/// <summary>
        /// 
        /// </summary>
        public string LoginName
        {
            get { return m_LoginName; }
            set { m_LoginName = value; }
        }
		
		string m_Password;
		/// <summary>
        /// 
        /// </summary>
        public string Password
        {
            get { return m_Password; }
            set { m_Password = value; }
        }
		
		string m_MemberName;
		/// <summary>
        /// 
        /// </summary>
        public string MemberName
        {
            get { return m_MemberName; }
            set { m_MemberName = value; }
        }
		
		string m_MemberNo;
		/// <summary>
        /// 
        /// </summary>
        public string MemberNo
        {
            get { return m_MemberNo; }
            set { m_MemberNo = value; }
        }
		
		string m_CompanyName;
		/// <summary>
        /// 
        /// </summary>
        public string CompanyName
        {
            get { return m_CompanyName; }
            set { m_CompanyName = value; }
        }
		
		string m_Contact;
		/// <summary>
        /// 
        /// </summary>
        public string Contact
        {
            get { return m_Contact; }
            set { m_Contact = value; }
        }
		
		string m_IDNO;
		/// <summary>
        /// 
        /// </summary>
        public string IDNO
        {
            get { return m_IDNO; }
            set { m_IDNO = value; }
        }
		
		string m_TelePhone;
		/// <summary>
        /// 
        /// </summary>
        public string TelePhone
        {
            get { return m_TelePhone; }
            set { m_TelePhone = value; }
        }
		
		string m_Email;
		/// <summary>
        /// 
        /// </summary>
        public string Email
        {
            get { return m_Email; }
            set { m_Email = value; }
        }
		
		string m_Mobile;
		/// <summary>
        /// 
        /// </summary>
        public string Mobile
        {
            get { return m_Mobile; }
            set { m_Mobile = value; }
        }
		
		string m_Fax;
		/// <summary>
        /// 
        /// </summary>
        public string Fax
        {
            get { return m_Fax; }
            set { m_Fax = value; }
        }
		
		string m_Address;
		/// <summary>
        /// 
        /// </summary>
        public string Address
        {
            get { return m_Address; }
            set { m_Address = value; }
        }
		
		string m_ZipCode;
		/// <summary>
        /// 
        /// </summary>
        public string ZipCode
        {
            get { return m_ZipCode; }
            set { m_ZipCode = value; }
        }
		
		string m_WebSite;
		/// <summary>
        /// 
        /// </summary>
        public string WebSite
        {
            get { return m_WebSite; }
            set { m_WebSite = value; }
        }
		
		string m_Description;
		/// <summary>
        /// 
        /// </summary>
        public string Description
        {
            get { return m_Description; }
            set { m_Description = value; }
        }
		
		DateTime? m_LastLogin;
		/// <summary>
        /// 
        /// </summary>
        public DateTime? LastLogin
        {
            get { return m_LastLogin; }
            set { m_LastLogin = value; }
        }
		
		bool m_Activity;
		/// <summary>
        /// 
        /// </summary>
        public bool Activity
        {
            get { return m_Activity; }
            set { m_Activity = value; }
        }
		
		int m_MemberStatus;
		/// <summary>
        /// 
        /// </summary>
        public int MemberStatus
        {
            get { return m_MemberStatus; }
            set { m_MemberStatus = value; }
        }
		
		int m_Creater;
		/// <summary>
        /// 
        /// </summary>
        public int Creater
        {
            get { return m_Creater; }
            set { m_Creater = value; }
        }
		
		string m_CreatedBy;
		/// <summary>
        /// 
        /// </summary>
        public string CreatedBy
        {
            get { return m_CreatedBy; }
            set { m_CreatedBy = value; }
        }
		
		DateTime m_Created;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Created
        {
            get { return m_Created; }
            set { m_Created = value; }
        }
		
		DateTime m_Modified;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Modified
        {
            get { return m_Modified; }
            set { m_Modified = value; }
        }
		
		string m_ModifiedBy;
		/// <summary>
        /// 
        /// </summary>
        public string ModifiedBy
        {
            get { return m_ModifiedBy; }
            set { m_ModifiedBy = value; }
        }
		
		int? m_ModifiedByID;
		/// <summary>
        /// 
        /// </summary>
        public int? ModifiedByID
        {
            get { return m_ModifiedByID; }
            set { m_ModifiedByID = value; }
        }
		
		bool m_IsTransfer;
		/// <summary>
        /// 
        /// </summary>
        public bool IsTransfer
        {
            get { return m_IsTransfer; }
            set { m_IsTransfer = value; }
        }
		
		string m_AccountNo;
		/// <summary>
        /// 
        /// </summary>
        public string AccountNo
        {
            get { return m_AccountNo; }
            set { m_AccountNo = value; }
        }
		
		string m_AccountName;
		/// <summary>
        /// 
        /// </summary>
        public string AccountName
        {
            get { return m_AccountName; }
            set { m_AccountName = value; }
        }
		
		int m_ShoppingTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int ShoppingTypeID
        {
            get { return m_ShoppingTypeID; }
            set { m_ShoppingTypeID = value; }
        }
		
		int? m_CityID;
		/// <summary>
        /// 
        /// </summary>
        public int? CityID
        {
            get { return m_CityID; }
            set { m_CityID = value; }
        }
		
		int? m_ProvinceID;
		/// <summary>
        /// 
        /// </summary>
        public int? ProvinceID
        {
            get { return m_ProvinceID; }
            set { m_ProvinceID = value; }
        }
		
		string m_CityName;
		/// <summary>
        /// 
        /// </summary>
        public string CityName
        {
            get { return m_CityName; }
            set { m_CityName = value; }
        }
		
		string m_ProvinceName;
		/// <summary>
        /// 
        /// </summary>
        public string ProvinceName
        {
            get { return m_ProvinceName; }
            set { m_ProvinceName = value; }
        }
		
		string m_RegionName;
		/// <summary>
        /// 
        /// </summary>
        public string RegionName
        {
            get { return m_RegionName; }
            set { m_RegionName = value; }
        }
		
		string m_AreaName;
		/// <summary>
        /// 
        /// </summary>
        public string AreaName
        {
            get { return m_AreaName; }
            set { m_AreaName = value; }
        }
		
		int? m_AreAreaID;
		/// <summary>
        /// 
        /// </summary>
        public int? AreAreaID
        {
            get { return m_AreAreaID; }
            set { m_AreAreaID = value; }
        }
		
		string m_ParentName;
		/// <summary>
        /// 
        /// </summary>
        public string ParentName
        {
            get { return m_ParentName; }
            set { m_ParentName = value; }
        }
		
		
		#region IDbSessionEntity Members
		public void ReadDBData(RowDataReader reader)
        {
            m_MembersID = reader[TableViewMembers.MembersID];
            m_RegionID = reader[TableViewMembers.RegionID];
            m_AreaID = reader[TableViewMembers.AreaID];
            m_ApproveStatusID = reader[TableViewMembers.ApproveStatusID];
            m_LoginName = reader[TableViewMembers.LoginName];
            m_Password = reader[TableViewMembers.Password];
            m_MemberName = reader[TableViewMembers.MemberName];
            m_MemberNo = reader[TableViewMembers.MemberNo];
            m_CompanyName = reader[TableViewMembers.CompanyName];
            m_Contact = reader[TableViewMembers.Contact];
            m_IDNO = reader[TableViewMembers.IDNO];
            m_TelePhone = reader[TableViewMembers.TelePhone];
            m_Email = reader[TableViewMembers.Email];
            m_Mobile = reader[TableViewMembers.Mobile];
            m_Fax = reader[TableViewMembers.Fax];
            m_Address = reader[TableViewMembers.Address];
            m_ZipCode = reader[TableViewMembers.ZipCode];
            m_WebSite = reader[TableViewMembers.WebSite];
            m_Description = reader[TableViewMembers.Description];
            m_LastLogin = reader[TableViewMembers.LastLogin];
            m_Activity = reader[TableViewMembers.Activity];
            m_MemberStatus = reader[TableViewMembers.MemberStatus];
            m_Creater = reader[TableViewMembers.Creater];
            m_CreatedBy = reader[TableViewMembers.CreatedBy];
            m_Created = reader[TableViewMembers.Created];
            m_Modified = reader[TableViewMembers.Modified];
            m_ModifiedBy = reader[TableViewMembers.ModifiedBy];
            m_ModifiedByID = reader[TableViewMembers.ModifiedByID];
            m_IsTransfer = reader[TableViewMembers.IsTransfer];
            m_AccountNo = reader[TableViewMembers.AccountNo];
            m_AccountName = reader[TableViewMembers.AccountName];
            m_ShoppingTypeID = reader[TableViewMembers.ShoppingTypeID];
            m_CityID = reader[TableViewMembers.CityID];
            m_ProvinceID = reader[TableViewMembers.ProvinceID];
            m_CityName = reader[TableViewMembers.CityName];
            m_ProvinceName = reader[TableViewMembers.ProvinceName];
            m_RegionName = reader[TableViewMembers.RegionName];
            m_AreaName = reader[TableViewMembers.AreaName];
            m_AreAreaID = reader[TableViewMembers.AreAreaID];
            m_ParentName = reader[TableViewMembers.ParentName];
        }
		
		public void WriteDBData(RowDataWriter writer)
        {
        }

        public void SetIdentityAfterInsert(DBObject idd)
        {
        }
		
		public string TableName
        {
            get { return TableViewMembers.Table; }
        }
		#endregion
		
		
		#region IJsonClass Members

        public void JsonDeSerializeObj(JsonHashTable hashToRead)
        {
             m_MembersID = hashToRead["MembersID"];
			 
             m_RegionID = hashToRead["RegionID"];
			 
             m_AreaID = hashToRead["AreaID"];
			 
             m_ApproveStatusID = hashToRead["ApproveStatusID"];
			 
             m_LoginName = hashToRead["LoginName"];
			 
             m_Password = hashToRead["Password"];
			 
             m_MemberName = hashToRead["MemberName"];
			 
             m_MemberNo = hashToRead["MemberNo"];
			 
             m_CompanyName = hashToRead["CompanyName"];
			 
             m_Contact = hashToRead["Contact"];
			 
             m_IDNO = hashToRead["IDNO"];
			 
             m_TelePhone = hashToRead["TelePhone"];
			 
             m_Email = hashToRead["Email"];
			 
             m_Mobile = hashToRead["Mobile"];
			 
             m_Fax = hashToRead["Fax"];
			 
             m_Address = hashToRead["Address"];
			 
             m_ZipCode = hashToRead["ZipCode"];
			 
             m_WebSite = hashToRead["WebSite"];
			 
             m_Description = hashToRead["Description"];
			 
             m_LastLogin = hashToRead["LastLogin"];
			 
             m_Activity = hashToRead["Activity"];
			 
             m_MemberStatus = hashToRead["MemberStatus"];
			 
             m_Creater = hashToRead["Creater"];
			 
             m_CreatedBy = hashToRead["CreatedBy"];
			 
             m_Created = hashToRead["Created"];
			 
             m_Modified = hashToRead["Modified"];
			 
             m_ModifiedBy = hashToRead["ModifiedBy"];
			 
             m_ModifiedByID = hashToRead["ModifiedByID"];
			 
             m_IsTransfer = hashToRead["IsTransfer"];
			 
             m_AccountNo = hashToRead["AccountNo"];
			 
             m_AccountName = hashToRead["AccountName"];
			 
             m_ShoppingTypeID = hashToRead["ShoppingTypeID"];
			 
             m_CityID = hashToRead["CityID"];
			 
             m_ProvinceID = hashToRead["ProvinceID"];
			 
             m_CityName = hashToRead["CityName"];
			 
             m_ProvinceName = hashToRead["ProvinceName"];
			 
             m_RegionName = hashToRead["RegionName"];
			 
             m_AreaName = hashToRead["AreaName"];
			 
             m_AreAreaID = hashToRead["AreAreaID"];
			 
             m_ParentName = hashToRead["ParentName"];
			 
        }

        public void JsonSerializeObj(JsonHashTable hashToFill)
        {
            hashToFill["MembersID"] = MembersID;
			
            hashToFill["RegionID"] = RegionID;
			
            hashToFill["AreaID"] = AreaID;
			
            hashToFill["ApproveStatusID"] = ApproveStatusID;
			
            hashToFill["LoginName"] = LoginName;
			
            hashToFill["Password"] = Password;
			
            hashToFill["MemberName"] = MemberName;
			
            hashToFill["MemberNo"] = MemberNo;
			
            hashToFill["CompanyName"] = CompanyName;
			
            hashToFill["Contact"] = Contact;
			
            hashToFill["IDNO"] = IDNO;
			
            hashToFill["TelePhone"] = TelePhone;
			
            hashToFill["Email"] = Email;
			
            hashToFill["Mobile"] = Mobile;
			
            hashToFill["Fax"] = Fax;
			
            hashToFill["Address"] = Address;
			
            hashToFill["ZipCode"] = ZipCode;
			
            hashToFill["WebSite"] = WebSite;
			
            hashToFill["Description"] = Description;
			
            hashToFill["LastLogin"] = LastLogin;
			
            hashToFill["Activity"] = Activity;
			
            hashToFill["MemberStatus"] = MemberStatus;
			
            hashToFill["Creater"] = Creater;
			
            hashToFill["CreatedBy"] = CreatedBy;
			
            hashToFill["Created"] = Created;
			
            hashToFill["Modified"] = Modified;
			
            hashToFill["ModifiedBy"] = ModifiedBy;
			
            hashToFill["ModifiedByID"] = ModifiedByID;
			
            hashToFill["IsTransfer"] = IsTransfer;
			
            hashToFill["AccountNo"] = AccountNo;
			
            hashToFill["AccountName"] = AccountName;
			
            hashToFill["ShoppingTypeID"] = ShoppingTypeID;
			
            hashToFill["CityID"] = CityID;
			
            hashToFill["ProvinceID"] = ProvinceID;
			
            hashToFill["CityName"] = CityName;
			
            hashToFill["ProvinceName"] = ProvinceName;
			
            hashToFill["RegionName"] = RegionName;
			
            hashToFill["AreaName"] = AreaName;
			
            hashToFill["AreAreaID"] = AreAreaID;
			
            hashToFill["ParentName"] = ParentName;
			
        }

        #endregion
		
	}
}
